/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package test.db_work;

/**
 *
 * @author snbm
 */
public class Speciality_extract {
    private String study_load;
    private String practice_period;
    private String gos_full_name;
    private String thesis_execution_time;
    private String extract_series;
    private int hours_total;
    private int speciality_specialization_id;   //DEFAULT 1
    private int thesis_type_id;                 //DEFAULT 1

    @Override
    public String toString(){
        return new StringBuilder()
            .append("study_load (учебная нагрузка) - " + study_load)
            .append("\npractice_period (период практики) - " + practice_period)
            .append("\ngos_full_name (полное название ГОСа) - " + gos_full_name)
            .append("\nthesis_execution_time (время выполнения дипломной работы) - " + thesis_execution_time)
            .append("\nextract_series (серия выписки) - " + extract_series)
            .append("\nhours_total (всего часов) - " + hours_total)
            .append("\nspeciality_specialization_id (ид специализации) - " + speciality_specialization_id)
            .append("\nthesis_type_id - (ид типа диплома) - " + thesis_type_id)
            .toString();
    }

    public String make_INSERT_into_speciality_extract(int kafedra_speciality_id){
        return "INSERT INTO onpu.speciality_extract VALUES ("+kafedra_speciality_id+",'"+study_load+"','"+practice_period+"'," +
                "'"+gos_full_name+"','"+thesis_execution_time+"'," +
                "'"+extract_series+"',"+hours_total+","+speciality_specialization_id+","+thesis_type_id+");";
    }

    /**
     * @return the study_load
     */
    public String getStudy_load() {
        return study_load;
    }

    /**
     * @param study_load the study_load to set
     */
    public void setStudy_load(String study_load) {
        this.study_load = study_load;
    }

    /**
     * @return the practice_period
     */
    public String getPractice_period() {
        return practice_period;
    }

    /**
     * @param practice_period the practice_period to set
     */
    public void setPractice_period(String practice_period) {
        this.practice_period = practice_period;
    }

    /**
     * @return the gos_full_name
     */
    public String getGos_full_name() {
        return gos_full_name;
    }

    /**
     * @param gos_full_name the gos_full_name to set
     */
    public void setGos_full_name(String gos_full_name) {
        this.gos_full_name = gos_full_name;
    }

    /**
     * @return the thesis_execution_time
     */
    public String getThesis_execution_time() {
        return thesis_execution_time;
    }

    /**
     * @param thesis_execution_time the thesis_execution_time to set
     */
    public void setThesis_execution_time(String thesis_execution_time) {
        this.thesis_execution_time = thesis_execution_time;
    }

    /**
     * @return the extract_series
     */
    public String getExtract_series() {
        return extract_series;
    }

    /**
     * @param extract_series the extract_series to set
     */
    public void setExtract_series(String extract_series) {
        this.extract_series = extract_series;
    }

    /**
     * @return the hours_total
     */
    public int getHours_total() {
        return hours_total;
    }

    /**
     * @param hours_total the hours_total to set
     */
    public void setHours_total(int hours_total) {
        this.hours_total = hours_total;
    }

    /**
     * @return the speciality_specialization_id
     */
    public int getSpeciality_specialization_id() {
        return speciality_specialization_id;
    }

    /**
     * @param speciality_specialization_id the speciality_specialization_id to set
     */
    public void setSpeciality_specialization_id(int speciality_specialization_id) {
        this.speciality_specialization_id = speciality_specialization_id;
    }

    /**
     * @return the thesis_type_id
     */
    public int getThesis_type_id() {
        return thesis_type_id;
    }

    /**
     * @param thesis_type_id the thesis_type_id to set
     */
    public void setThesis_type_id(int thesis_type_id) {
        this.thesis_type_id = thesis_type_id;
    }

}
